Skip to main content

📜 Stored Procedure

The Stored Procedure action allows you to execute a stored procedure on a selected database server. You can pass parameters to the procedure to control its execution and retrieve results.

Configuration​

  • Select Server: Choose the database server where the stored procedure resides.
  • Stored Procedure: Select the stored procedure you want to execute.
  • Parameters: Define one or more parameters to pass to the stored procedure. For each parameter:
    • Enter the parameter name.
    • Select the data type (e.g., String, Integer).
    • Provide the initial value or use an expression (fx) to dynamically assign it.
    • Use the plus (+) button to add more parameters or the trash icon to remove.

Features​

  • Executes complex business logic encapsulated in stored procedures.
  • Supports multiple parameter inputs for flexible procedure calls.
  • Integrates stored procedure execution into automated workflows.
  • Handles different data types for parameters.

Use Cases​

  • Perform batch updates or data processing in the database.
  • Run pre-defined reports or data transformations.
  • Call procedures for transaction processing or validation.
  • Leverage existing database logic within workflow automation.

Notes​

  • Ensure the selected server and stored procedure exist and are accessible.
  • Match parameter names and types with the stored procedure definition.
  • Use expressions for dynamic parameter values based on workflow data.

Tip: Combine Stored Procedure actions with other data retrieval or update actions for robust database automation.